Coronavirus - Statewide Available PPE and Bed Tracking

Statewide Available PPE and Bed Tracking

Note: Data on this page will now be updated Monday - Friday due to furloughs.

Statewide Available Bed Tracking for COVID-19* 05/29/2020**
	Total Number of Hospital Beds	Hospital Inpatient Beds	Hospital Inpatient Bed Occupied	ICU Beds	ICU Bed Occupied	Negative Pressure Isolation Total	Negative Pressure Isolation Available	Total Ventilators	Available Ventilators	Available Operating Room	Available Adult Med/Surg	Available Burn Care	Available Pediatric	Available Psych.	Total Morgue Capacity	Morgue Available
Region 1	1670	1501	1003	208	140	212	124	215	170	39	224	0	40	55	43	29
Region 2N	5030	4833	3248	530	376	371	148	618	432	76	967	0	65	85	178	127
Region 2S	7189	6241	4712	987	707	557	142	1280	791	94	888	14	110	53	469	337
Region 3	2907	2447	1752	365	278	248	104	342	221	73	748	1	105	15	74	65
Region 5	2127	1518	1140	185	111	269	142	224	165	65	426	10	56	88	34	28
Region 6	2678	2330	1535	411	284	230	95	450	361	115	473	35	65	25	113	95
Region 7	1001	975	514	106	59	173	123	95	78	38	278	0	33	12	30	27
Region 8	670	563	247	59	37	109	81	96	89	37	256	19	48	18	31	31
Total	23272	20408	14151	2851	1992	2169	959	3320	2307	537	4260	79	522	351	972	739

*95% response rate
** Data is preliminary and subject to change
.

**COVID-19 Metrics**
HCC Region	Region 1	Region 2 North	Region 2 South	Region 3	Region 5	Region 6	Region 7	Region 8	Total
# of ED Discharges	92	125	135	36	52	78	14	11	543
# In Critical Care	23	83	140	62	14	42	3	3	371
# on Ventilators	20	58	107	31	7	24	0	3	250
# of Inpatients	25	170	311	104	40	122	1	1	774

Statewide Hospital Available PPE Tracking for COVID-19* 05/29/2020**
	CAPRs	Coveralls	Elastomeric Respirator	Elastomeric Respirator Filters	Face Shields	Gloves	Goggles	N95 Respirator Masks	PAPR Batteries	PAPR Filters	PAPRs	Surgical Gowns	Surgical Isolation Gowns	Surgical Masks/ Facemasks
Region 1	50	48,624	77	21	128,442	1,264,856	5,891	117,144	214	411	137	19,561	125,860	1,067,873
Region 2N	185	8,895	24	73	139,494	5,496,807	20,001	227,138	331	596	342	75,446	229,077	502,465
Region 2S	109	29,005	2	1,815	283,381	3,668,843	18,340	518,078	806	1,292	1,126	47,630	306,316	1,786,616
Region 3	235	3,351	8	12	95,028	4,776,479	33,760	198,745	209	406	158	18,579	248,639	920,514
Region 5	157	1,913	23	64	22,542	1,254,020	8,379	45,504	258	314	178	12,448	53,965	144,756
Region 6	136	1,685	14	36	116,420	11,749,634	42,261	355,238	401	915	371	76,632	54,157	1,923,892
Region 7	46	3,434	0	0	95,619	5,222,938	10,756	55,786	340	264	256	25,772	26,202	628,475
Region 8	4	2,882	45	190	32,332	2,086,676	1,140	88,217	148	361	155	12,046	71,747	369,263
Total	922	99,789	193	2,211	913,258	35,520,253	140,528	1,605,850	2,707	4,559	2,723	288,114	1,115,963	7,343,854

*86% Reporting
**Data is preliminary and subject to change

Data is self-reported by hospitals daily to the EM Resource System per MDHHS Director Robert Gordon’s Emergency Order.
Changes in inventory numbers have likely occurred since reporting was completed.
This information will be updated daily by 7 p.m.
Information about Healthcare Coalition Regions is available on the MDHHS website.

Region1 – Clinton, Eaton, Gratiot, Hillsdale, Ingham, Jackson, Lenawee, Livingston and Shiawassee counties.
Region 2S – City of Detroit and Monroe, Washtenaw and Wayne counties.
Region 2N - Macomb, Oakland and St. Clair counties.
Region 3 - Saginaw, Alcona, Iosco, Ogemaw, Arenac, Gladwin, Midland, Bay, Genesee, Tuscola, Lapeer, Sanilac and Huron counties.
Region 5 - Allegan, Barry, Calhoun, Branch, St. Joseph, Cass, Berrien, Van Buren and Kalamazoo counties.
Region 6 - Clare, Ionia, Isabella, Kent, Lake, Mason, Mecosta, Montcalm, Muskegon, Newaygo, Oceana, Osceola and Ottawa counties.
Region 7 - Manistee, Wexford, Missaukee, Roscommon, Benzie, Leelanau, Grand Traverse, Kalkaska, Crawford, Oscoda, Antrim, Otsego, Montmorency, Alpena, Presque Ilse, Cheboygan, Emmet and Charlevoix counties.
Region 8 - Chippewa, Mackinac, Luce, Schoolcraft, Delta, Alger, Marquette, Dickinson, Menominee, Baraga, Iron, Gogebic, Ontonagon, Houghton and Keweenaw counties.

PPE Days On Hand as of 05/28/2020
Health System/Hospital	N95 Masks	Surgical Masks	Surgical Gowns	Shields	Gloves	System/Independent
Ascension	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Aspirus	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Baraga County Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Beaumont	21+ days	0-6 days	7-14 days	21+ days	7-14 days	Health System
Bronson	21+ days	0-6 days	21+ days	21+ days	7-14 days	Health System
Covenant	21+ days	21+ days	21+ days	21+ days	15-21 days	Health System
Deckerville Community Hospital	21+ days	15-21 days	21+ days	21+ days	21+ days	Independent
Detroit Medical Center	21+ days	7-14 days	21+ days	21+ days	7-14 days	Health System
Dickinson Memorial Health Care System	21+ days	21+ days	15-21 days	21+ days	21+ days	Independent
Eaton Rapids Medical Center	21+ days	15-21 days	7-14 days	21+ days	21+ days	Independent
Harbor Beach Community Hospital	15-21 days	15-21 days	21+ days	21+ days	21+ days	Independent
Helen Newberry Joy Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Henry Ford Health System	21+ days	7-14 days	21+ days	21+ days	7-14 days	Health System
Hills and Dales General Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Hillsdale Hospital	7-14 days	15-21 days	21+ days	21+ days	21+ days	Independent
Holland Community Hospital	21+ days	21+ days	15-21 days	21+ days	21+ days	Independent
Hurley Medical Center	21+ days	0-6 days	0-6 days	21+ days	21+ days	Health System
Kalkaska Memorial Health Center	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Mackinac Straits Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Marlette Regional Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
McKenzie Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
McLaren	21+ days	15-21 days	21+ days	21+ days	21+ days	Health System
Memorial Healthcare	21+ days	7-14 days	21+ days	21+ days	21+ days	Independent
Metro	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Michigan Medicine	21+ days	21+ days	7-14 days	7-14 days	0-6 days	Health System
MidMichigan Health	7-14 days	0-6 days	7-14 days	21+ days	0-6 days	Health System
Munising Memorial Hospital	21+ days	0-6 days	21+ days	21+ days	21+ days	Independent
Munson Health System	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
North Ottawa Community Hosp	21+ days	7-14 days	15-21 days	21+ days	21+ days	Independent
OSF St. Francis Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Oaklawn Hospital	21+ days	7-14 days	21+ days	21+ days	21+ days	Independent
Pontiac General Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Prime Health	21+ days	15-21 days	21+ days	21+ days	0-6 days	Health System
ProMedica	21+ days	15-21 days	15-21 days	21+ days	7-14 days	Health System
Scheurer Hospital	21+ days	0-6 days	21+ days	21+ days	21+ days	Independent
Schoolcraft Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Sheridan Community Hospital	21+ days	0-6 days	21+ days	21+ days	7-14 days	Independent
Sparrow Health System	21+ days	21+ days	21+ days	21+ days	7-14 days	Health System
Spectrum	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
Straith Hospital	7-14 days	15-21 days	21+ days	21+ days	21+ days	Independent
Sturgis Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent
Three Rivers Health	0-6 days	15-21 days	21+ days	21+ days	21+ days	Independent
Trinity	21+ days	15-21 days	21+ days	21+ days	7-14 days	Health System
UP Health	21+ days	21+ days	21+ days	21+ days	21+ days	Health System
War Memorial Hospital	21+ days	21+ days	21+ days	21+ days	21+ days	Independent

Patient Census as of 05/28/2020
Health System/Hospital	COVID-19 Patients	COVID-19 Patients in ICU	Bed Occupancy
Ascension	170	39	71%
Aspirus	0	1	28%
Baraga County Memorial Hospital	0	0	20%
Beaumont	227	70	68%
Bronson	23	9	73%
Covenant	46	16	78%
Deckerville Community Hospital	1	0	8%
Detroit Medical Center	86	41	96%
Dickinson Memorial Health Care System	4	1	49%
Eaton Rapids Medical Center	1	0	30%
Harbor Beach Community Hospital	0	0	20%
Helen Newberry Joy Hospital	0	0	28%
Henry Ford Health System	118	63	67%
Hills and Dales General Hospital	0	0	39%
Hillsdale Hospital	1	0	56%
Holland Community Hospital	12	2	64%
Hurley Medical Center	21	12	84%
Kalkaska Memorial Health Center	0	0	25%
Mackinac Straits Hospital	0	0	40%
Marlette Regional Hospital	0	0	8%
McKenzie Memorial Hospital	0	0	4%
McLaren	123	37	70%
Memorial Healthcare	1	0	32%
Metro	9	2	53%
Michigan Medicine	45	40	83%
MidMichigan Health	39	0	54%
Munising Memorial Hospital	0	0	7%
Munson Health System	2	2	53%
North Ottawa Community Hosp	1	0	29%
Oaklawn Hospital	2	0	38%
OSF St. Francis Hospital	0	0	27%
Pontiac General Hospital	0	0	11%
Prime Health	17	6	62%
ProMedica	10	6	56%
Scheurer Hospital	1	0	9%
Schoolcraft Memorial Hospital	1	0	58%
Sheridan Community Hospital	0	0	7%
Sparrow Health System	12	0	69%
Spectrum	76	27	58%
Straith Hospital	0	0	17%
Sturgis Hospital	5	0	63%
Three Rivers Health	6	0	34%
Trinity	161	30	73%
UP Health	2	0	67%
War Memorial Hospital	0	0	29%
Grand Total	1,223	404	68%

The data reflects the status in health systems and hospitals 48 hours prior to the time that the data was posted to this website.This information has been compiled by the Michigan Health & Hospital Association (MHA) on behalf of the Michigan Department of Health & Human Services (MDHHS). The data is from the state of Michigan's EMResource data system. Hospitals are required to enter data into EMResource. The data reflects the status in the hospital or health system from the previous 48 hour period.General Information:Tableau Dashboard of Health System/Hospital Data

The information is aggregated by health system for those hospitals that are part of a health system. This is because systems are centrally tracking and distributing personal protection equipment (PPE) amongst their various facilities and looking at patient surge and load from a system perspective. Non-system hospitals are identified as individual hospitals.

Data Dictionary:

PPE Days on Hand - This is a calculation based on a number of factors including the amount of PPE, the number of COVID-19 patients, beds, industry standard usage and conservation techniques.

COVID-19 Patients – Confirmed positive patients, as well as patients who are currently pending and under investigation (PUI). This includes COVID-19 patients in the ICU.

COVID-19 Patients in ICU - Confirmed postive patients and suspected patients in intensive care unit (ICU).

Bed Occupancy - The percentage of staffed inpatient beds occupied by any patient regardless of COVID-19 status. This includes surge or overlow beds.

Navigation:

There are three data tabs that display information:

Dashboard - PPE status and Patient Census for a specific health system or hospital

Patient Census - Patient census for all health systems/hospitals in Michigan

PPE - Personal protective equipment status for all health systems/hospitals in Michigan